SQL Variables Parameters

Systemwide variables that contain the relevant parameters for SQL variables.

SQLVAR_INTERNAL

Description: Determines who can create and edit SQL - internal and SQL - internal SECURE Variable objects.

For security reasons, the creation of Variable objects of these types is deactivated by default because the execution of SQL statements on the AE database enables systemwide access to objects and other data. Important data records can also be modified or deleted.

Note: The internal SQL variables that are supplied by default in client 0 are not affected by this setting and can always be used.
Allowed values: YES and NO

YES: Allows users to create, edit, and use internal SQL variables on a system-wide basis. To do so, a user must have the Create and modify SQL-Internal variables privilege.

NO: Objects cannot be created anymore. The variable type SQLI is no longer listed in the Templates dialog (new object).
Default value: NO
Restart required: No

Description: Defines the maximum number of lines to be retrieved by Variable objects with the source SQL and SQLI.

The maximum number of rows must be equal to or higher than the number of agents in use. Otherwise, an error message is displayed, or some agents/values might not be shown.

Example

Job Status: FAULT_OTHER - Start impossible. Other error.

Message: U00003900 Error in object 'PCK.AUTOMIC_FILESYSTEM.PUB.ACTION.CREATE_DIR' (RunID '0001358760') prompt 'PCK.ITPA_SHARED.PRV.PROMPTSET.OVERWRITE_AGENT': Invalid value.

Note: This setting does not have any effect on variables of the types Filelist and Multi.
Allowed values: 0 to 500000

If you specify a very high value it may take longer to resolve Variable objects.
Default value: 200
Restart required: No